Range operators

Range operators are used to create ranges and to see if a value is within the range created. These operators test for consecutive values such as dates, text, or amounts which fall within a range.

In Range operator

Make Range operator (x To y)

Left end point excluded range (x _To y)

Right end point excluded range (x To_ y)

Both end points excluded range (x _To_ y)

Is > x

Is < x

Is >= x

Is <= x

Up from (upFrom x)

Up from but not including (upFrom_ x)

Up to (upTo x)

Up to but not including (upTo_ x)